﻿CREATE TABLE [cex].[Audit] (
    [Id]                INT           IDENTITY (1, 1) NOT NULL,
    [UserId]            INT           NOT NULL,
    [AuditKey]          VARCHAR (50)  NOT NULL,
    [StartDate]         DATETIME      NOT NULL,
    [EndDate]           DATETIME      NOT NULL,
    [CountryId]         INT			  NOT NULL,
    [State]             VARCHAR (100) NULL,
    [PeopleInHousehold] INT           NOT NULL,
    [Created]           DATETIME      NOT NULL,
    [Completed]         BIT           NOT NULL,
    [Deleted]           BIT           NOT NULL,
    [CID]               TIMESTAMP     NOT NULL
);

